Node / meshtastic / Meshtastic-Android / files / core / database / src / commonMain / kotlin / org / meshtastic / core / database / dao / DiscoveryDao.kt

Displaying Raw • Download

T8b949e/*

* Copyright (c) 2026 Meshtastic LLC

*

* This program is free software: you can redistribute it and/or modify

* it under the terms of the GNU General Public License as published by

* the Free Software Foundation, either version 3 of the License, or

* (at your option) any later version.

*

* This program is distributed in the hope that it will be useful,

* but WITHOUT ANY WARRANTY; without even the implied warranty of

* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

* GNU General Public License for more details.

*

* You should have received a copy of the GNU General Public License

* along with this program. If not, see <https://www.gnu.org/licenses/>.

*/

Tff7b72package T7ee787org.meshtastic.core.database.dao

Tff7b72import T7ee787androidx.room3.Dao

Tff7b72import T7ee787androidx.room3.Insert

Tff7b72import T7ee787androidx.room3.Query

Tff7b72import T7ee787androidx.room3.Transaction

Tff7b72import T7ee787androidx.room3.Update

Tff7b72import T7ee787kotlinx.coroutines.flow.Flow

Tff7b72import T7ee787org.meshtastic.core.database.entity.DiscoveredNodeEntity

Tff7b72import T7ee787org.meshtastic.core.database.entity.DiscoveryPresetResultEntity

Tff7b72import T7ee787org.meshtastic.core.database.entity.DiscoverySessionEntity

Tf0883e@Dao

Tf0883e@SuppressTb4b4b4(Ta5d6ff"Ta5d6ffTooManyFunctionsTa5d6ff"Tb4b4b4)

Tff7b72interface T56d364DiscoveryDao Tb4b4b4{

T8b949e// region Session operations

Tf0883e@Insert Tff7b72suspend Tff7b72fun Td2a8ffinsertSessionTb4b4b4(Te6edf3sessionTb4b4b4: Te6edf3DiscoverySessionEntityTb4b4b4)Tb4b4b4: Tffa657Long

Tf0883e@Update Tff7b72suspend Tff7b72fun Td2a8ffupdateSessionTb4b4b4(Te6edf3sessionTb4b4b4: Te6edf3DiscoverySessionEntityTb4b4b4)

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM discovery_session ORDER BY timestamp DESCTa5d6ff"Tb4b4b4)

Tff7b72fun Td2a8ffgetAllSessionsTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Te6edf3ListTff7b72<Te6edf3DiscoverySessionEntityTff7b72>Tff7b72>

T8b949e/** Snapshot used by DatabaseMerger to append a transport's discovery sessions to the unified DB. */

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM discovery_sessionTa5d6ff"Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffgetAllSessionsSnapshotTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Te6edf3DiscoverySessionEntityTff7b72>

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM discovery_session WHERE id = :sessionIdTa5d6ff"Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffgetSessionTb4b4b4(Te6edf3sessionIdTb4b4b4: Tffa657LongTb4b4b4)Tb4b4b4: Te6edf3DiscoverySessionEntity?

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM discovery_session WHERE id = :sessionIdTa5d6ff"Tb4b4b4)

Tff7b72fun Td2a8ffgetSessionFlowTb4b4b4(Te6edf3sessionIdTb4b4b4: Tffa657LongTb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Te6edf3DiscoverySessionEntity?Tff7b72>

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffDELETE FROM discovery_session WHERE id = :sessionIdTa5d6ff"Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffdeleteSessionTb4b4b4(Te6edf3sessionIdTb4b4b4: Tffa657LongTb4b4b4)

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffUPDATE discovery_session SET completion_status = 'interrupted' WHERE completion_status = 'in_progress'Ta5d6ff"Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffmarkInterruptedSessionsTb4b4b4(Tb4b4b4)

T8b949e/**

* The most recent session left mid-scan by a prior process (crash, BLE loss, or force-quit) for [deviceAddress] —

* "in_progress" if the process died before [markInterruptedSessions] ever ran, "interrupted" otherwise.

*/

Tf0883e@QueryTb4b4b4(

Ta5d6ff"""

Ta5d6ff SELECT * FROM discovery_session

WHERE device_address = :deviceAddress AND completion_status IN ('in_progress', 'interrupted')

ORDER BY timestamp DESC LIMIT 1

Ta5d6ff"""Tb4b4b4,

Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffgetInterruptedSessionTb4b4b4(Te6edf3deviceAddressTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Te6edf3DiscoverySessionEntity?

T8b949e// endregion

T8b949e// region Preset result operations

Tf0883e@Insert Tff7b72suspend Tff7b72fun Td2a8ffinsertPresetResultTb4b4b4(Te6edf3resultTb4b4b4: Te6edf3DiscoveryPresetResultEntityTb4b4b4)Tb4b4b4: Tffa657Long

Tf0883e@Update Tff7b72suspend Tff7b72fun Td2a8ffupdatePresetResultTb4b4b4(Te6edf3resultTb4b4b4: Te6edf3DiscoveryPresetResultEntityTb4b4b4)

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM discovery_preset_result WHERE session_id = :sessionIdTa5d6ff"Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffgetPresetResultsTb4b4b4(Te6edf3sessionIdTb4b4b4: Tffa657LongTb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Te6edf3DiscoveryPresetResultEntityTff7b72>

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM discovery_preset_result WHERE session_id = :sessionIdTa5d6ff"Tb4b4b4)

Tff7b72fun Td2a8ffgetPresetResultsFlowTb4b4b4(Te6edf3sessionIdTb4b4b4: Tffa657LongTb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Te6edf3ListTff7b72<Te6edf3DiscoveryPresetResultEntityTff7b72>Tff7b72>

T8b949e// endregion

T8b949e// region Discovered node operations

Tf0883e@Insert Tff7b72suspend Tff7b72fun Td2a8ffinsertDiscoveredNodeTb4b4b4(Te6edf3nodeTb4b4b4: Te6edf3DiscoveredNodeEntityTb4b4b4)Tb4b4b4: Tffa657Long

Tf0883e@Insert Tff7b72suspend Tff7b72fun Td2a8ffinsertDiscoveredNodesTb4b4b4(Te6edf3nodesTb4b4b4: Te6edf3ListTff7b72<Te6edf3DiscoveredNodeEntityTff7b72>Tb4b4b4)

Tf0883e@Update Tff7b72suspend Tff7b72fun Td2a8ffupdateDiscoveredNodeTb4b4b4(Te6edf3nodeTb4b4b4: Te6edf3DiscoveredNodeEntityTb4b4b4)

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM discovered_node WHERE preset_result_id = :presetResultIdTa5d6ff"Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffgetDiscoveredNodesTb4b4b4(Te6edf3presetResultIdTb4b4b4: Tffa657LongTb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Te6edf3DiscoveredNodeEntityTff7b72>

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM discovered_node WHERE preset_result_id = :presetResultIdTa5d6ff"Tb4b4b4)

Tff7b72fun Td2a8ffgetDiscoveredNodesFlowTb4b4b4(Te6edf3presetResultIdTb4b4b4: Tffa657LongTb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Te6edf3ListTff7b72<Te6edf3DiscoveredNodeEntityTff7b72>Tff7b72>

Tf0883e@QueryTb4b4b4(

Ta5d6ff"""

Ta5d6ff SELECT DISTINCT node_num FROM discovered_node dn

INNER JOIN discovery_preset_result dpr ON dn.preset_result_id = dpr.id

WHERE dpr.session_id = :sessionId

Ta5d6ff"""Tb4b4b4,

Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffgetUniqueNodeNumsTb4b4b4(Te6edf3sessionIdTb4b4b4: Tffa657LongTb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Tffa657LongTff7b72>

T8b949e// endregion

T8b949e// region Aggregate queries

Tf0883e@QueryTb4b4b4(

Ta5d6ff"""

Ta5d6ff SELECT COUNT(DISTINCT node_num) FROM discovered_node dn

INNER JOIN discovery_preset_result dpr ON dn.preset_result_id = dpr.id

WHERE dpr.session_id = :sessionId

Ta5d6ff"""Tb4b4b4,

Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffgetUniqueNodeCountTb4b4b4(Te6edf3sessionIdTb4b4b4: Tffa657LongTb4b4b4)Tb4b4b4: Tffa657Int

Tf0883e@QueryTb4b4b4(

Ta5d6ff"""

Ta5d6ff SELECT MAX(distance_from_user) FROM discovered_node dn

INNER JOIN discovery_preset_result dpr ON dn.preset_result_id = dpr.id

WHERE dpr.session_id = :sessionId

Ta5d6ff"""Tb4b4b4,

Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffgetMaxDistanceTb4b4b4(Te6edf3sessionIdTb4b4b4: Tffa657LongTb4b4b4)Tb4b4b4: Tffa657Double?

Tf0883e@Transaction

Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM discovery_session WHERE id = :sessionIdTa5d6ff"Tb4b4b4)

Tff7b72suspend Tff7b72fun Td2a8ffgetSessionWithResultsTb4b4b4(Te6edf3sessionIdTb4b4b4: Tffa657LongTb4b4b4)Tb4b4b4: Te6edf3DiscoverySessionEntity?

T8b949e// endregion

Tb4b4b4}